from openpyxl import Workbook

wb = Workbook()
for i in range(1,200):
    # wb.create_sheet(title=str(i), index=i)
    # 其实我觉得没有必要加的
    wb.create_sheet(title=str(i))

wb.save(r'D:\Desktop\exceltest\my1.xlsx')